使用SQL存储过程时需要特别注意的问题

CREATE procedure p_splitpage    
@sql nvarchar(4000), --要执行的sql语句 
@page int=1,    --要显示的页码 
@pageSize int,  --每页的大小 
@pageCount int=0 out, --总页数 
@recordCount int=0 out --总记录数 
as 
set nocount on 
declare @p1 int 
exec sp_cursoropen @p1 output,@sql,@scrollopt=1,@ccopt=1,@rowcount=@pagecount output 
set @recordCount = @pageCount 
select @pagecount=ceiling(1.0*@pagecount/@pagesize) 
 ,@page=(@page-1)*@pagesize+1 
exec sp_cursorfetch @p1,16,@page,@pagesize  
exec sp_cursorclose @p1 
GO 
ASP页面的内容 
sql = "Select id, c_s_name from tabNews where deleted<>1 Order By id Desc" 
page = cint(page_get) 
if page_post<>""then 
 page = cint(page_post) 
end if 
if not page > 0 then  
 page = 1 
end if 
pagesize=20’每页的条数 
set cmd = server.CreateObject("adodb.command") 
cmd.ActiveConnection = conn 
cmd.CommandType = 4 
cmd.CommandText = "p_SplitPage" 
cmd.Parameters.Append cmd.CreateParameter("@sql",8,1, 4000, sql) 
cmd.Parameters.Append cmd.CreateParameter("@page",4,1, 4, page) 
cmd.Parameters.Append cmd.CreateParameter("@pageSize",4,1, 4, pageSize) 
cmd.Parameters.Append cmd.CreateParameter("@pageCount",4,2, 4, pageCount) 
cmd.Parameters.Append cmd.CreateParameter("@recordCount",4,2, 4, recordCount) 
set rs = cmd.Execute 
set rs = rs.NextRecordSet 
pageCount = cmd.Parameters("@pageCount").value 
recordCount = cmd.Parameters("@recordCount").value 
if pageCount = 0 then pageCount = 1 
if page>pageCount then  
 response.Redirect("?page="&pageCount)  
end if 
set rs = cmd.Execute

id = rs("id") 
newsTitle = rs("newsTitle") 
...